** user = // insert user name
** password = // insert password
** package = STATA
** project = GSOEP


/* 
This script uploads the county-year level external datasets into SOEP remote.

The dataframe contains county measures in 2014 on the number of employees working in brown occupations (brownness_share, brown1_share,...) which is the main treatment of our study.
Moreover, it contains county socio-economic covariates, such as population, pop. density, share manufacturing, etc.

We save these dataframes in the intermediate files folder.
*/

quietly{

********************************************
*** 1. Upload county brownness dataframe ***
********************************************

input county brown0_3_share_1999
1001 0.249016808196187
1002 0.233622411082064
1003 0.307490032044226
1004 0.320964454070582
1051 0.345164303303048
1053 0.333166433006209
1054 0.320309571582916
1055 0.306192062281793
1056 0.285502400437153
1057 0.284986845455317
1058 0.313147678293033
1059 0.316874312935141
1060 0.313227931488801
1061 0.307694526989989
1062 0.314069073928522
2000 0.256915828946114
3101 0.277289434366951
3102 0.376127965578375
3103 0.322950180364629
3151 0.318361244019139
3153 0.34294226070556
3154 0.327201677468547
3155 0.363116980425213
3157 0.379651818438117
3158 0.296016389710904
3159 0.310560699106527
3241 0.279867421677566
3251 0.336557349447178
3252 0.280301823684001
3254 0.312594212070652
3255 0.41839161455122
3256 0.378018292682927
3257 0.332039121246375
3351 0.287455687542758
3352 0.363029291242981
3353 0.325693085082169
3354 0.373481702060967
3355 0.325504300912183
3356 0.306667305756603
3357 0.345356054621375
3358 0.373365100637828
3359 0.403811757224055
3360 0.325425437066326
3361 0.358166041998254
3401 0.316752577319588
3402 0.370231547973517
3403 0.242255881805202
3404 0.297167142220778
3405 0.30540993155672
3451 0.350188431918729
3452 0.341537699640956
3453 0.40885092394282
3454 0.376774063361808
3455 0.350810412573674
3456 0.378045751814344
3457 0.36002096191918
3458 0.346142034548944
3459 0.400089691844449
3460 0.411171379111368
3461 0.429119539586747
3462 0.382481751824818
4011 0.297622835515959
4012 0.341153255864942
5111 0.239311837115218
5112 0.33183948483982
5113 0.246828158639459
5114 0.335692436196991
5116 0.300922367409685
5117 0.287185472520682
5119 0.319874242823282
5120 0.363481337795494
5122 0.356003107631626
5124 0.291608396952398
5154 0.313852131905062
5158 0.302102013817434
5162 0.321777285844171
5166 0.336341821567995
5170 0.322046901772243
5314 0.191312017343648
5315 0.249966415979387
5316 0.359992662569935
5334 0.301637629523094
5358 0.369933759964073
5362 0.351946994827269
5366 0.352652049408044
5370 0.334664646742873
5374 0.348533939978859
5378 0.307632623876101
5382 0.294943864209323
5512 0.2903976592632
5513 0.298516742161826
5515 0.218522183084656
5554 0.402289761095149
5558 0.31029812882675
5562 0.316050333684802
5566 0.36294682073113
5570 0.359407930803435
5711 0.272762322346538
5754 0.387767117807351
5758 0.364265647825598
5762 0.341281848089715
5766 0.349098537144336
5770 0.34036274968858
5774 0.321710621275543
5911 0.301601522297663
5913 0.261376631570646
5914 0.335440913160251
5915 0.294897122409423
5916 0.301759595025433
5954 0.344912105257998
5958 0.377301044039689
5962 0.396417710858091
5966 0.412952890604439
5970 0.356921976768907
5974 0.325486859519758
5978 0.345025046557717
6411 0.222305037324129
6412 0.242612362335441
6413 0.217781807975473
6414 0.219454153342753
6431 0.308513909342482
6432 0.303111403004679
6433 0.322755216901896
6434 0.226361232000672
6435 0.333643396985824
6436 0.176288241299989
6437 0.386349206349206
6438 0.262840080894418
6439 0.291643110448682
6440 0.289745790132662
6531 0.27876787161805
6532 0.34731211684537
6533 0.295128477187803
6534 0.340221382786896
6535 0.362739580919594
6611 0.256541340408551
6631 0.353916603066676
6632 0.36529944640161
6633 0.340653786581886
6634 0.333856110976122
6635 0.37882387339644
6636 0.378057844562934
7111 0.236931279811136
7131 0.350123631225715
7132 0.383391664015272
7133 0.310349563903578
7134 0.286079479432954
7135 0.35828811050814
7137 0.338433445458914
7138 0.33440746008029
7140 0.349558723693143
7141 0.338559875693047
7143 0.376878530571642
7211 0.287602759532367
7231 0.399981030067343
7232 0.374665249734325
7233 0.379157566302652
7235 0.354428787116256
7311 0.296714384814278
7312 0.29807538731832
7313 0.197580413967089
7314 0.398773839115994
7315 0.259054708448393
7316 0.239400239400239
7317 0.278150633855332
7318 0.275569208529093
7319 0.343796711509716
7320 0.307871843836198
7331 0.305750813794405
7332 0.348110384572759
7333 0.332970561027371
7334 0.341621098200046
7335 0.323421038974519
7336 0.355172151706316
7337 0.338784049184527
7338 0.32430426716141
7339 0.311056344834251
7340 0.302076436954559
8111 0.213554226390474
8115 0.274947468580264
8116 0.304611900924165
8117 0.345208141301911
8118 0.311717646485802
8119 0.283409297377882
8121 0.296234011933444
8125 0.358214702076002
8126 0.326593331544672
8127 0.346426365911529
8128 0.352891525037071
8135 0.344985451807842
8136 0.354165841682176
8211 0.322631498000615
8212 0.241267355603405
8215 0.351841731336758
8216 0.388134455517117
8221 0.219444815160817
8222 0.296492198206429
8225 0.33471015524854
8226 0.312367162592986
8231 0.29856384100627
8235 0.335343817151787
8236 0.379914695618457
8237 0.346592468744541
8311 0.241952778420201
8315 0.363964686998395
8316 0.329724337607357
8317 0.358432036097011
8325 0.354950180199279
8326 0.335181576848135
8327 0.367016166088809
8335 0.326219775608191
8336 0.333478384826613
8337 0.368386359641413
8415 0.318339280327067
8416 0.293940040366912
8417 0.398957648605503
8421 0.268918352728108
8425 0.395170738057014
8426 0.361841541021287
8435 0.27905988956534
8436 0.313327923502062
8437 0.381329744816587
9161 0.286764285305726
9162 0.214156200918115
9163 0.270875616120615
9171 0.466617286473233
9172 0.335226490430951
9173 0.331834821141866
9174 0.300227123994303
9175 0.285383903792784
9176 0.382915270855462
9177 0.350053143651378
9178 0.354824613005698
9179 0.250168178026532
9180 0.343539449029223
9181 0.325398993249307
9182 0.324375743162901
9183 0.373797284829313
9184 0.219973939409126
9185 0.406731885259493
9186 0.38301532686894
9187 0.346573897659227
9188 0.247994207096307
9189 0.352166197291771
9190 0.359106672215286
9261 0.241304271524341
9262 0.301505559746777
9263 0.268490282645305
9271 0.39188076197561
9272 0.447705005067812
9273 0.386063904377149
9274 0.434651963358422
9275 0.407077106465641
9276 0.458561551584807
9277 0.370908274822866
9278 0.461902836346831
9279 0.395726798643107
9361 0.318962599424607
9362 0.290799072555562
9363 0.328950123539512
9371 0.410922410922411
9372 0.394037088351274
9373 0.443591209868475
9374 0.425780098538763
9375 0.35825885468388
9376 0.44372803240148
9377 0.457706766917293
9461 0.269587266412393
9462 0.289296022699477
9463 0.251743864181583
9464 0.32641056422569
9471 0.442922726746653
9472 0.410922753500022
9473 0.545604413023492
9474 0.356995237667356
9475 0.452183012615546
9476 0.422250363142016
9477 0.384576495294392
9478 0.469323302934601
9479 0.428201193520887
9561 0.296472962436362
9562 0.18240564984368
9563 0.282964456531933
9564 0.266540483379056
9565 0.309512937595129
9571 0.441823994209542
9572 0.360746609877548
9573 0.373015873015873
9574 0.355036554743228
9575 0.374138144585277
9576 0.402016852221583
9577 0.397062466820032
9661 0.292056309703369
9662 0.321815990357573
9663 0.227561984006636
9671 0.368987217734033
9672 0.39871587044277
9673 0.376075409590783
9674 0.395862960568843
9675 0.397738427107464
9676 0.387669325908872
9677 0.367498618992618
9678 0.384929689572831
9679 0.355902466969816
9761 0.272420951772597
9762 0.280877412555168
9763 0.27757624613731
9764 0.335146712358107
9771 0.364347603553541
9772 0.396068598552999
9773 0.347122964709349
9774 0.36177983155698
9775 0.369076589955353
9776 0.374459147237975
9777 0.400412592550726
9778 0.394594594594595
9779 0.358813386975552
9780 0.376536510260229
10041 0.290061672227277
10042 0.387873160977003
10043 0.322466493911784
10044 0.347124321626848
10045 0.361306173656973
10046 0.334123332868628
11000 0.25162727291867
12051 0.324412989789524
12052 0.270321029259474
12053 0.259605185621685
12054 0.234399056800055
12060 0.311954281829577
12061 0.346894384919037
12062 0.366947904111424
12063 0.348201078099536
12064 0.31520823763589
12065 0.325059924224851
12066 0.35667012567739
12067 0.338197777103812
12068 0.297203662459787
12069 0.333517900091707
12070 0.344421393157284
12071 0.376660053681877
12072 0.322190385227634
12073 0.311638316920322
13003 0.283793972809312
13004 0.257787088593638
13071 0.293586851434096
13072 0.319619053175043
13073 0.317311949001404
13074 0.35886063685491
13075 0.285334941267872
13076 0.347273364895669
14511 0.26080347091547
14521 0.368685181715235
14522 0.356291221572509
14523 0.367754970636885
14524 0.349390409512026
14612 0.249174405663303
14625 0.340601090163525
14626 0.32439445483057
14627 0.351807517356955
14628 0.352088479817423
14713 0.25404035119427
14729 0.347326972948538
14730 0.348771695594126
15001 0.288455276407084
15002 0.242076803226102
15003 0.245701689933872
15081 0.31673630825173
15082 0.35792023415028
15083 0.375895695275039
15084 0.324161126319906
15085 0.341060353955529
15086 0.37906558251133
15087 0.319802061516981
15088 0.382119148693695
15089 0.314509048684471
15090 0.340816276019107
15091 0.331471057716542
16051 0.25521091927642
16052 0.276135511576651
16053 0.25417489077643
16054 0.253543611823327
16055 0.247267259945548
16061 0.408931273734403
16062 0.320356416696567
16063 0.356102046223137
16064 0.323395126244568
16065 0.301414380146977
16066 0.354417548554515
16067 0.356172888960103
16068 0.364464171318752
16069 0.394677318446508
16070 0.337691741665252
16071 0.324728883458072
16072 0.385507246376812
16073 0.346168949099298
16074 0.388778831187208
16075 0.37093043942359
16076 0.388589531829628
16077 0.357007749100006
end


*************************
*** 2. Save dataframe ***
*************************

save $mydata/user/cty_brownness_1999, replace

}

* End of Code
